How to: Draw lines on an Excel worksheet or chart.
Solution:
Click 'Line' toolbar button from the 'Drawing' toolbar. Position the cursor where the line is to begin. Press and hold down the mouse then drag it to the end of the line. Release the mouse.
1) Display the 'Drawing' toolbar if it is not already displayed on the screen.
a) Select the 'View' menu and select 'Toolbars...'. (This displays the Toolbars dialog box.)
b) Select the 'Drawings' check box.
c) Click 'OK'.
2) Click 'Line' toolbar button.
Drawing Toolbar
3) Position the cursor where the arrow is to begin.
4) Press and hold down the mouse then drag it to where the line is to end.
NOTE: Perfect vertical, horizontal and 45 degree angle lines can be drawn by pressing and holding down SHIFT while dragging the mouse.
5) Release the mouse button.
6) Close the 'Drawings' toolbar.
NOTE: The style, color and weight of the line can be changed by selecting the 'Format' menu and selecting 'Object...'.
